﻿CREATE PROCEDURE [dbo].[proc_AppMenu_GetList]
	/*
	(
	@parameter1 int = 5,
	@parameter2 datatype OUTPUT
	)
	*/
AS
	Select 
	MenuId,
	ParentId,
	Title,
	CId,
	AId,
	(Select CName From AppController Where Id=AppMenu.CId) As ControllerName,
	(Select AName From AppAction Where Id=AppMenu.AId) As ActionName,
	CreateTime,
	Sort
	From AppMenu
	RETURN
